UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pSHS4bw2FhNFKlK+btyW4sfgmaAC/hO2j3hndDy+SDA='
WHERE
key_id = 'f31b669d5932f475d83478d8e366b6a687d4e35fa51d9f3b95e8993596e19dc7'
AND (
token = 'pSHS4bw2FhNFKlK+btyW4sfgmaAC/hO2j3hndDy+SDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)