UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1UpOvLntcA8HIbX6H/YcnoSn/ZrX3PnXXIRRJ072v8='
WHERE
key_id = '4d2f763cadebc318e326006d3d33a20ea646d2adb39269f42a67f330668fb7b8'
AND (
token = 'a1UpOvLntcA8HIbX6H/YcnoSn/ZrX3PnXXIRRJ072v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)