UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdYfavZLMx7MKSeh8HONEEKo6Njo4sFdGjqQ/Pw6rrI='
WHERE
key_id = 'c96628b6fd4670a4f6f573e86921e6df239736c818a769dc8501341cfce22fd9'
AND (
token = 'XdYfavZLMx7MKSeh8HONEEKo6Njo4sFdGjqQ/Pw6rrI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)