UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdWJaA1p4yly+sVSB4MoPKHupB4handUw4+p3gOEa+M='
WHERE
key_id = 'fead7bdbf5ce502abf0017f4977901af29ed810b56411c3dc22fd6aa4b9cd3bf'
AND (
token = 'XdWJaA1p4yly+sVSB4MoPKHupB4handUw4+p3gOEa+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)