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