UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2STOVmRBxn/dscQ99DrNb1SiSioLeQEk6au8JWw2LDo='
WHERE
key_id = '47e47c00bc7cd963192561bf9ddef4940fd392c84f52838f957d79ce7e995304'
AND (
token = '2STOVmRBxn/dscQ99DrNb1SiSioLeQEk6au8JWw2LDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)