UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iT9SqUhOiD/TNcz0sJoNoUauuRFhTNHto33Cil0gTj0='
WHERE
key_id = '3c6cecc5f43ab50b9b1288655df176e8c6dd6c85d0120efa7bfec7ede27a01e6'
AND (
token = 'iT9SqUhOiD/TNcz0sJoNoUauuRFhTNHto33Cil0gTj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)