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