UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vzf3ZGY0Av0fwJYc75RAtCwO59V8JXrJq6qAsKHbQOA='
WHERE
key_id = '08adaec2cbe9bc456eeefdaf3cd0d6b3564accbe273ad9ac9a9dbfcf9ddf4e3e'
AND (
token = 'Vzf3ZGY0Av0fwJYc75RAtCwO59V8JXrJq6qAsKHbQOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)