UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pH9JmnzERy0QI7YSLBmYQhfaFVW8ufSU4LlKzKjGtw='
WHERE
key_id = '8dc4957bf8aabcc273648bf6c17ee5db309df48d6adeb204a36755cc4a4cd11f'
AND (
token = '6pH9JmnzERy0QI7YSLBmYQhfaFVW8ufSU4LlKzKjGtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)