UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ON938+CuiE3iyjpPkfQcLokJk6Ko2ofd3DRzpsQNANU='
WHERE
key_id = 'c42f71fc74d3053f3d55ea660dc60a4f254e22e495982e3258a5e846d7913df7'
AND (
token = 'ON938+CuiE3iyjpPkfQcLokJk6Ko2ofd3DRzpsQNANU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)