UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'itX+SE8nyVwoSF3ke4rg5qoWaZWScP3lEzM6yFnVv2E='
WHERE
key_id = '02d2946e6113613c1f483206f6593e99245be77201f11ea4bbedd1af9bc10069'
AND (
token = 'itX+SE8nyVwoSF3ke4rg5qoWaZWScP3lEzM6yFnVv2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)