UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hv7Fom7Ev3knTOi4jU70g9os7ItpoIX+kToq3+Ct/JY='
WHERE
key_id = 'e77e8ac18bf60ddd9044ff71638f152ba75c13533faa25548873ff23feb7576c'
AND (
token = 'Hv7Fom7Ev3knTOi4jU70g9os7ItpoIX+kToq3+Ct/JY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)