UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cLRa1oJvlAr9Ivw/TQlA6GanshT/8LeFxxeTdpzLCEI='
WHERE
key_id = 'be8e9a91333cdb58ba19a3a90820038ef7e32d292aade5dc2d66486199498575'
AND (
token = 'cLRa1oJvlAr9Ivw/TQlA6GanshT/8LeFxxeTdpzLCEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)