UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WNeJ2O/6qZaNhHIxZAnkqCwmS/xaNEA7+HAGTxSpHHg='
WHERE
key_id = 'f8ef4441ddc21408b15e5f36d6961a3994b060a110c940cb5f4502c3f31ec250'
AND (
token = 'WNeJ2O/6qZaNhHIxZAnkqCwmS/xaNEA7+HAGTxSpHHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)