UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'frDeMk0+0Hf+ORmb+wN567aRXCheOfbXBrdfVV+UeSs='
WHERE
key_id = '1f337485898ba07749814594af7a740e4f49dc188aec71d159f886bb423b7757'
AND (
token = 'frDeMk0+0Hf+ORmb+wN567aRXCheOfbXBrdfVV+UeSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)