UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OdJc1nPrSTMaPZj6gSlUDDFGy2pehZp1FOSvnc6QIOw='
WHERE
key_id = 'f9ce6ff08dbefc894f987479b03004844ba534d93c50d8a0a968b9e7a2fe2115'
AND (
token = 'OdJc1nPrSTMaPZj6gSlUDDFGy2pehZp1FOSvnc6QIOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)