UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7EdmtQDkgSBVZdEyTJz+3WSPeuTRNNmUxWqXfFfXmg='
WHERE
key_id = '3e63d0d2a5caa9f128ecedb5dbfbd18227ebd8ad7f95cb4d1c0986ee50fe56b7'
AND (
token = 'r7EdmtQDkgSBVZdEyTJz+3WSPeuTRNNmUxWqXfFfXmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)