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