UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OM6CA7hn/hOERcraU8P1q/XUEFsBCT9emgi2kt8+LUU='
WHERE
key_id = 'fe61412732798ec15b8d09e071069e6953b64905afdbf074aab5472eeb27bdb4'
AND (
token = 'OM6CA7hn/hOERcraU8P1q/XUEFsBCT9emgi2kt8+LUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)