UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nfm16ikPCZjErYSBlROCfFmXgV+3Mr2n847CGhXR+7Q='
WHERE
key_id = 'e3d92c06318954a6cc0be106fce9981092bc5c7c254d1f733e2c6d2b415a4db8'
AND (
token = 'Nfm16ikPCZjErYSBlROCfFmXgV+3Mr2n847CGhXR+7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)