UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9tmisBY4jmKbtCQZgTPGZNiABv8qWKcb3XwbK0ThnRw='
WHERE
key_id = 'd8564c73c30f604f74e40d7f4a36cccf2a0d8fa0a389287a00a20499a5ceb95c'
AND (
token = '9tmisBY4jmKbtCQZgTPGZNiABv8qWKcb3XwbK0ThnRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)