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