UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q4rNnFZbUi4zOSHyZbdjPJvGw8JoDvx6BFOmsxee13k='
WHERE
key_id = '7f9d6427d73791000f0dc786fa0f9d977a9cde0adcf906ab72a2b43cdc352ee8'
AND (
token = 'q4rNnFZbUi4zOSHyZbdjPJvGw8JoDvx6BFOmsxee13k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)