UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NCKwKAme2bY0YXCGZMI2qqhrLNq5O70fRY9zhRDGwQg='
WHERE
key_id = 'cc2d9f5a1667809b72f4981a0471f100b6e529e1d98a735df4c3a1aac8baa239'
AND (
token = 'NCKwKAme2bY0YXCGZMI2qqhrLNq5O70fRY9zhRDGwQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)