UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4PNFUKPPj4a80awfqjXbhW1w4oNURn8XH6C/sBdPADM='
WHERE
key_id = 'e29bf43e8b368ab575b3ca31aea318935cb18af62ff7bd5123afbe9e4bc0e5c2'
AND (
token = '4PNFUKPPj4a80awfqjXbhW1w4oNURn8XH6C/sBdPADM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)