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