UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QC4q7il/Y2I6B3wBYWl2m5V0qhwVdB1bTWsiKdgEqcM='
WHERE
key_id = '82a045feced9dfa319c448cb698a8b6c789a65500e13378ddb4a4775900b958c'
AND (
token = 'QC4q7il/Y2I6B3wBYWl2m5V0qhwVdB1bTWsiKdgEqcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)