UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GmXTyn0+vgffLrxxozjsvx7SbOlKZv8dbcUay2ZMUrA='
WHERE
key_id = 'c2a7a27cb75963f89fffd5dc3fd1f5d2bacdfac0662c2afa6be6292ed8059991'
AND (
token = 'GmXTyn0+vgffLrxxozjsvx7SbOlKZv8dbcUay2ZMUrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)