UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XO3fHWQpFnwHOrLqKkyJcQMOYdEQn66HfeeBdt0oB2M='
WHERE
key_id = '6da968bdc6a10bdb8ebed7ad3568e464314b087b239d334c05c51d1846b843d9'
AND (
token = 'XO3fHWQpFnwHOrLqKkyJcQMOYdEQn66HfeeBdt0oB2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)