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