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