UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6KxWNcpJQTZMYhWpq0yC+Q3zjIuJil9cZK98VabdBc4='
WHERE
key_id = 'c039fff235c58b2d63bc2184bde8297f7167bb28352e05596502dbff3fc6ef5c'
AND (
token = '6KxWNcpJQTZMYhWpq0yC+Q3zjIuJil9cZK98VabdBc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)