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