UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WVSpxejE19dJZ5tmGYspDI2Wphjj4hxDJlielnnRLeY='
WHERE
key_id = '65f747f9ea050f66a0e8096c41a3297263bf0ff3e72f027475101386980193ab'
AND (
token = 'WVSpxejE19dJZ5tmGYspDI2Wphjj4hxDJlielnnRLeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)