UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47GjZ6B6407OAHaGu4MXwuA7qXfC9BeGPO7PQF5nENY='
WHERE
key_id = 'c6116b0dc30da4ca94ad2a4cda41733447635bae5df7db2b48485c96683760a6'
AND (
token = '47GjZ6B6407OAHaGu4MXwuA7qXfC9BeGPO7PQF5nENY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)